/****** Object:  Table [dbo].[DB_AmmeterTimeDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_AmmeterTimeDatas](
	[AmmeterNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingTime] [datetime] NOT NULL,
	[ReadingBeginTime] [datetime] NULL,
	[ReadingEndTime] [datetime] NULL,
	[OldTimeData] [numeric](18, 2) NULL,
	[NewTimeData] [numeric](18, 2) NULL,
	[TimeTotalData] [numeric](18, 2) NULL,
	[AmmeterPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_AmmeterTimeDatas] PRIMARY KEY CLUSTERED 
(
	[AmmeterNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC,
	[ReadingTime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_WaterTimeDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_WaterTimeDatas](
	[WaterNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingTime] [datetime] NOT NULL,
	[ReadingBeginTime] [datetime] NULL,
	[ReadingEndTime] [datetime] NULL,
	[OldTimeData] [numeric](18, 2) NULL,
	[NewTimeData] [numeric](18, 2) NULL,
	[TimeTotalData] [numeric](18, 2) NULL,
	[WaterPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_WaterTimeDatas] PRIMARY KEY CLUSTERED 
(
	[WaterNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC,
	[ReadingTime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_HeatTimeDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_HeatTimeDatas](
	[HeatNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingTime] [datetime] NOT NULL,
	[ReadingBeginTime] [datetime] NULL,
	[ReadingEndTime] [datetime] NULL,
	[OldTimeData] [numeric](18, 2) NULL,
	[NewTimeData] [numeric](18, 2) NULL,
	[TimeTotalData] [numeric](18, 2) NULL,
	[HeatPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_HeatTimeDatas] PRIMARY KEY CLUSTERED 
(
	[HeatNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC,
	[ReadingTime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_GasTimeDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_GasTimeDatas](
	[GasNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingTime] [datetime] NOT NULL,
	[ReadingBeginTime] [datetime] NULL,
	[ReadingEndTime] [datetime] NULL,
	[OldTimeData] [numeric](18, 2) NULL,
	[NewTimeData] [numeric](18, 2) NULL,
	[TimeTotalData] [numeric](18, 2) NULL,
	[GasPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_GasTimeDatas] PRIMARY KEY CLUSTERED 
(
	[GasNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC,
	[ReadingTime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
